UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iwSSdEobuHM6CqM249iP+oeT4+jBU0OaPmieRURwg2M='
WHERE
key_id = 'e7845ebe65366b38c4ca0be1e337e717ef4dfa408e799127a13b0748733270f7'
AND (
token = 'iwSSdEobuHM6CqM249iP+oeT4+jBU0OaPmieRURwg2M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)