UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sjBSvncjwj+bnWCKVPNIqA+Zr4YROdqW5QILFfh7C04='
WHERE
key_id = 'a8029fa50f36c50be817d4a1eb7fcc0e0292517a884c2a93ed91066df04e9c94'
AND (
token = 'sjBSvncjwj+bnWCKVPNIqA+Zr4YROdqW5QILFfh7C04='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)