UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HUFN4wy49Se/zKwEqzIGM1fthBxbWE97x2pOz5db8ng='
WHERE
key_id = '896e6e63d82b097229c26987bcde31860991af3be51913b3aaceeb23c0b94b5e'
AND (
token = 'HUFN4wy49Se/zKwEqzIGM1fthBxbWE97x2pOz5db8ng='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)