UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'mVT/dOJhBXr6Xb/BFkgVJkGGkNL+a1+tzVlLRmgp0rc=' 
WHERE 
  key_id = 'be9b86eb6eaf734a40e1a580d49c2e4dab59d4073b26771c6aa2f71a90e04ee6' 
  AND (
    token = 'mVT/dOJhBXr6Xb/BFkgVJkGGkNL+a1+tzVlLRmgp0rc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044