UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L1qosbw/NhDjOm4H2aEdc4Y56abscOuKKH7zzFW4kik='
WHERE
key_id = '8fa86bd1009f07054a93e0c9a7ace77c9ca0f88abc338c8d7ea2d70bbaad2c44'
AND (
token = 'L1qosbw/NhDjOm4H2aEdc4Y56abscOuKKH7zzFW4kik='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)