UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'TR7xWwQtP3vcPzmMGwXrFKm+xheDqRTysed3z9J8FRs=' 
WHERE 
  key_id = 'd4fc250fe156eb902e5ab9f8430cf74a13e754f5b9548f1966f91fb3fae3de32' 
  AND (
    token = 'TR7xWwQtP3vcPzmMGwXrFKm+xheDqRTysed3z9J8FRs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033