UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aOUzC48bwO4VY0mqs3ZRLrrIFDElFtPO1zSNbJBKVjU='
WHERE
key_id = '2a71945111cabfa178a9e4fee90b4e9bd329016feef6a6b471094007033d9dee'
AND (
token = 'aOUzC48bwO4VY0mqs3ZRLrrIFDElFtPO1zSNbJBKVjU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)