UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0FyImHDW6Axl6E2zwZZcmY4QN68R4dnSMaI3Sv++8y8='
WHERE
key_id = 'c42c03ef3678845def916499720e770f29e8fdcb4dfda26e02460490610ea040'
AND (
token = '0FyImHDW6Axl6E2zwZZcmY4QN68R4dnSMaI3Sv++8y8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)