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