UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vX2ZUCugLrD550NmylbX4fHtnHkWKv/tfU2UhkY0txs='
WHERE
key_id = '59e654f13f6c08f1d9b732e419411559db5ec68faa4b4e1b10a8526806d5ff94'
AND (
token = 'vX2ZUCugLrD550NmylbX4fHtnHkWKv/tfU2UhkY0txs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)