UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '0nkjYZi7pYuqUFHVG5RyzJH9UfzcHCiahzpn42BhZpQ=' 
WHERE 
  key_id = 'e04fdc2f5ebff36e9ef486616ec1a4a60b10a28146b206498a836c048f4daa6a' 
  AND (
    token = '0nkjYZi7pYuqUFHVG5RyzJH9UfzcHCiahzpn42BhZpQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033