UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1y3ElGaUfkvY4P8p5xDbJI0g6eEijdFhnGx8zvHkFc8='
WHERE
key_id = 'cc679549602409bc28bd738484c51d0d4f19dabfbad31425a4e4fd9a96947ead'
AND (
token = '1y3ElGaUfkvY4P8p5xDbJI0g6eEijdFhnGx8zvHkFc8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)