UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N5OYki3uxYJ7UfIg3An1pUrEUkIWaz8KvaK8tYGlAPM='
WHERE
key_id = 'e1eeaea1edb46af2b6974b0c49e778fcc7e278f76c686114d6ae8bfcff871055'
AND (
token = 'N5OYki3uxYJ7UfIg3An1pUrEUkIWaz8KvaK8tYGlAPM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)