UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u6Hr3y46u23CXCj2frtQDorvEhWt3ltItMrzzzxW+ZM='
WHERE
key_id = '9e0759d4c95c5e680e36182fbeec2b0476c081778de761c2e0b60676bef15b1e'
AND (
token = 'u6Hr3y46u23CXCj2frtQDorvEhWt3ltItMrzzzxW+ZM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)