UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'SG6p6Iz1tkgO9eKIn7Zh8+ToPiCktfnqj2SYesbCRGU=' 
WHERE 
  key_id = '006854b87df5b50554efd203bdb8c2ef7ae6af473c41ff9f26107eac82b2e668' 
  AND (
    token = 'SG6p6Iz1tkgO9eKIn7Zh8+ToPiCktfnqj2SYesbCRGU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00019