UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'djhXBM83F3rZL+AdToi0z9ByrNz1Zko+hatpA8yuVIU=' 
WHERE 
  key_id = 'c434fc6d4f0e8c73e3d48a6be57a31174821ab95f07e99f7c6b2fe0d7d0bcbdc' 
  AND (
    token = 'djhXBM83F3rZL+AdToi0z9ByrNz1Zko+hatpA8yuVIU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00018