UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X9tXDylZ/PFM9Ec6424WWRbFTGbiEL3H3o7gdwhpTis='
WHERE
key_id = 'e4c51b5a88cfabbaa4b3f11e7f7a2834b22a71c2be420038480b08fac1e24ee8'
AND (
token = 'X9tXDylZ/PFM9Ec6424WWRbFTGbiEL3H3o7gdwhpTis='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)