UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KMDZBO6CNiERIMQBxcgvZa2h34BGQ4iropiu3YyVdF4='
WHERE
key_id = 'ce26121de4ef52a2cf1b7e72f04b815a9a368e86e704b17f67f6d109e073a91b'
AND (
token = 'KMDZBO6CNiERIMQBxcgvZa2h34BGQ4iropiu3YyVdF4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)