UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'PMKCFE5r2N+f0AguPW+xDvbhPE488kQ1bOnYA3fQFOY=' 
WHERE 
  key_id = 'd040f20bbb0e3408ea8b351f21cffa40525f4ba98c9d1790e99c4092ef44ff82' 
  AND (
    token = 'PMKCFE5r2N+f0AguPW+xDvbhPE488kQ1bOnYA3fQFOY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030