UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'BAoCGA9f6O0w26PTHuWY2MBGelHpmC7ZJFcSeTHAVHc=' 
WHERE 
  key_id = '129fb2672f9bd068c23ef1b9d1ee55b922ba484de459a222a9a10c2d19b34730' 
  AND (
    token = 'BAoCGA9f6O0w26PTHuWY2MBGelHpmC7ZJFcSeTHAVHc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029