UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'IpG0WPPLJLnFnQY4pc9c7bsnlR90X5DvyM/FCH/70fQ=' 
WHERE 
  key_id = '022417f00a216d5cac6c670d3df6be90e6bc89800f6245fbbe2877ab9f4a7402' 
  AND (
    token = 'IpG0WPPLJLnFnQY4pc9c7bsnlR90X5DvyM/FCH/70fQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032