UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cNqVcZsJqQ8VZxL+ZzWu6L82ZJH9hs2BiNexNUTi51Q='
WHERE
key_id = 'ab22c1bfe49f39d1f427030d8f6b4edc1dff417e5cf18d44a6c09ac9d72e8e9b'
AND (
token = 'cNqVcZsJqQ8VZxL+ZzWu6L82ZJH9hs2BiNexNUTi51Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)