UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'XeyUFKh8eGGmB4nG6aMb6dMTbCLp2RzZeKTyrrG7ZeE=' 
WHERE 
  key_id = '2801a2532dad26379e2b53dc749cf21de2a72fa9105ae3853a8beeeb8c924ae9' 
  AND (
    token = 'XeyUFKh8eGGmB4nG6aMb6dMTbCLp2RzZeKTyrrG7ZeE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026