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