UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RtzHcd0WIjI5cRbjwl0kTZsGviNUhDMF1ZuyD8/P29s='
WHERE
key_id = 'a1a4bab1082f597011942729bb04e0bf981d79c983cee3cc2f8162348c3a66e2'
AND (
token = 'RtzHcd0WIjI5cRbjwl0kTZsGviNUhDMF1ZuyD8/P29s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)