UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kKW0u+QFEggdfvzLzQBy3QH5CFQjbT16OlZVQOiXV6Q='
WHERE
key_id = 'a76c0e6a1ec58fa802446091f1dca77875f2a8e6ecfef6b70a6d9ae8fef203fd'
AND (
token = 'kKW0u+QFEggdfvzLzQBy3QH5CFQjbT16OlZVQOiXV6Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)