UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'UgDgS19o0vCO9kWAgZNn2CsfeR40aqp1Omf9+7OG2Ys=' 
WHERE 
  key_id = 'cc70036c072aac3f8fd7b49fcb517332ca98a0e3897e105305508d335db912e7' 
  AND (
    token = 'UgDgS19o0vCO9kWAgZNn2CsfeR40aqp1Omf9+7OG2Ys=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036