UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'If5EUH9d3bh9ul3sLUTybxdLugag9FG+BmJiciFW9L8='
WHERE
key_id = 'a3e472226b96a21f94c9124f1b8d4c74a834ce3afbfe8f6be2998dc1efbc501b'
AND (
token = 'If5EUH9d3bh9ul3sLUTybxdLugag9FG+BmJiciFW9L8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)