UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C9hsURO7d06N0ISKLlDvyk63YL/xOLQGCoqZqZoEMK0='
WHERE
key_id = 'e16aca7ecd54ac22217dbfccbe2419ed37854486f4c3a4b76fb30ff98f9fb08e'
AND (
token = 'C9hsURO7d06N0ISKLlDvyk63YL/xOLQGCoqZqZoEMK0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)