UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KE6sw+irETPW36e3Ag6xLIq1aATcRg0hkVWqdJvnOok='
WHERE
key_id = 'd257a7ad261e75d59db5fb380ebcafaf71ce30af147b024bd1c729ce4b2db261'
AND (
token = 'KE6sw+irETPW36e3Ag6xLIq1aATcRg0hkVWqdJvnOok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)