UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yt0uBQynmX6EQ6dBPYMgVh5X0Qf8BiHKwqec+kAXRJQ='
WHERE
key_id = '39bcc9249b58cd0785e2d41e184dc13c088aa8235262a86c0bcd1d09da614bc3'
AND (
token = 'yt0uBQynmX6EQ6dBPYMgVh5X0Qf8BiHKwqec+kAXRJQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)