UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wmuzwdIysf3k6es99HnfiPsQ88PCuV6YriMs0B5jXrw='
WHERE
key_id = '7d2bf80a90e8402b95fb0cc67d4fd0a5914c32dcf6492c9c0899db18c8783868'
AND (
token = 'wmuzwdIysf3k6es99HnfiPsQ88PCuV6YriMs0B5jXrw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)