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