UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UVMpZ4N9UrbSjMqfyNlIEWlWAh1jCKxUKjH0z+k3IO8='
WHERE
key_id = '10e5b52378f8b71f113149b95604647cfd01aa920950fbce733e151f99e23e3e'
AND (
token = 'UVMpZ4N9UrbSjMqfyNlIEWlWAh1jCKxUKjH0z+k3IO8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)