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