UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2cP3Ea72r1plGxIW70fc3iC+TWHgImvNK5uZOVc/NeM=' 
WHERE 
  key_id = 'fe04b4e1ac5ffc1134e398e7989c8b8ae9372759e5aec9166be029c4103ca1d4' 
  AND (
    token = '2cP3Ea72r1plGxIW70fc3iC+TWHgImvNK5uZOVc/NeM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030