UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9W38ObBvAPiU31WOK6kQZ+cMFqbyFR3YYGyMIRZhJy0='
WHERE
key_id = 'bc2f7c1b82d88d6cbe9a420912769cb56b3350d2785e74db1c04748685bdfea0'
AND (
token = '9W38ObBvAPiU31WOK6kQZ+cMFqbyFR3YYGyMIRZhJy0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)