UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9JwefO0xESKYfzPGWobcvGfptbEh1rTjJbVMKc8UpU8='
WHERE
key_id = '9cd99d68813b752612fb73151b124d9a940794e1a127d411e413a78957b4ac5c'
AND (
token = '9JwefO0xESKYfzPGWobcvGfptbEh1rTjJbVMKc8UpU8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)